package br.usp.pcs.acs.negocios.dao.interfaces;

import java.util.ArrayList;

import br.usp.pcs.acs.negocios.dto.AeronaveDto;

public interface AeronaveDaoInterface
{
	static String CRUD_C = "INSERT INTO aeronave VALUES (?,?,?,?,?)";
	static String CRUD_R = "SELECT * FROM aeronave";
	static String CRUD_U = "UPDATE aeronave SET VOO_Portao_id=?,VOO_id=?,modelo=?,capacidade=? WHERE id=?";
	static String CRUD_D = "DELETE FROM aeronave WHERE id = ?";
	
	public void insert(AeronaveDto dto);
	public void remove(int i);
	public void edit(AeronaveDto dto);
	public ArrayList<AeronaveDto> findAll();
	public AeronaveDto findById(int id);

}
